Nick Korna
Nick Korna
Reactions
-
Re: MULTIPLE IF STATEMENT
The error looks to be caused by the ” at the end of the NOT YET VALID portion, if you change this over to " it should work: =IF([VALID FROM DATE]@row > TODAY(), "NOT YET VALID", IF(…1 · -
Re: Formula Help - using multiple IFBLANKS in a single formula
Hi @MOC, Would something like this work? =IFERROR(IF([Incident Status]@row = "P1 (Red)", NETWORKDAYS([P1 Date]@row, TODAY()), NETWORKDAYS([P1 Date]@row, MIN([P2 Date]@row:[P4 Date]@row))), …1 · -
Re: Formula with Symbols
Hi @TolerDo, You can use a nested IF & COUNTIF formula. In this example you have 3 checkbox columns "Check 1", "Check 2", "Check 3" adjacent to one another. In your …1 · -
Re: Trying to target entire column in a different sheet with a formula
Hi @Andrew Skaggs, For the cross sheet reference you can use COUNTIF combined with AND in your IF statement: =IF(AND([Assigned To]63 = "Yes", COUNTIF({Status}, "Approved") = 0), &…1 · -
Re: Why are my symbols all red instead of red, yellow and green?
Hi, @Erica Lozano Your formulas are checking the whole column, if you amend instances of [Status Option]:[Status Option] to [Status Option]@row, it will check the row and not the whole column. This s…1 ·
